package com.fs.jzzn.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

import com.fs.jzzn.pojo.Stock;

public interface StockRepository extends JpaRepository<Stock,String>, JpaSpecificationExecutor<Stock>{
	
	
	List<Stock> findByMNoAndMNameAndWarehouseNameAndLocationOrderByMCountAsc(String mNo,String mName,String warehouseName,String location);
	
	List<Stock> findByMNoAndMNameAndWarehouseNameAndLocationAndMTypeOrderByMCountAsc(String mNo,String mName,String warehouseName,String location,String mType);
}